Merged_Data Profiling Report

Dataset statistics

Number of variables	34
Number of observations	75670
Missing cells	85293
Missing cells (%)	3.3%
Duplicate rows	297
Duplicate rows (%)	0.4%
Total size in memory	126.4 MiB
Average record size in memory	1.7 KiB

Variable types

Categorical	18
Numeric	7
Text	4
DateTime	4
Boolean	1

Alerts

`Compactor` has constant value ""	Constant
Dataset has 297 (0.4%) duplicate rows	Duplicates
`Address` is highly overall correlated with `Asset Type` and 5 other fields	High correlation
`Asset Category` is highly overall correlated with `Charge Code Desc.` and 7 other fields	High correlation
`Asset Type` is highly overall correlated with `Address` and 3 other fields	High correlation
`Charge Code Desc.` is highly overall correlated with `Asset Category` and 3 other fields	High correlation
`Charge Group` is highly overall correlated with `Charge Code Desc.` and 3 other fields	High correlation
`Charge Sub-Type` is highly overall correlated with `Address` and 3 other fields	High correlation
`City` is highly overall correlated with `Address` and 5 other fields	High correlation
`Container Size` is highly overall correlated with `Container Type` and 5 other fields	High correlation
`Container Type` is highly overall correlated with `Asset Category` and 6 other fields	High correlation
`Location ID` is highly overall correlated with `Address` and 4 other fields	High correlation
`Original Volume` is highly overall correlated with `Trash Tons`	High correlation
`Pounds per Yard` is highly overall correlated with `Address` and 9 other fields	High correlation
`Quantity` is highly overall correlated with `Charge Group` and 1 other fields	High correlation
`Recycle Tons` is highly overall correlated with `Asset Category` and 2 other fields	High correlation
`Report Period` is highly overall correlated with `Service Period`	High correlation
`Service Period` is highly overall correlated with `Report Period`	High correlation
`State` is highly overall correlated with `Address` and 2 other fields	High correlation
`Tons Derived` is highly overall correlated with `Asset Category` and 6 other fields	High correlation
`Trash Tons` is highly overall correlated with `Original Volume`	High correlation
`UOM for Volume` is highly overall correlated with `Asset Category` and 4 other fields	High correlation
`Unit of Measure` is highly overall correlated with `Charge Code Desc.` and 2 other fields	High correlation
`Waste Stream` is highly overall correlated with `Asset Category` and 7 other fields	High correlation
`Waste Type` is highly overall correlated with `Asset Category` and 6 other fields	High correlation
`Container Type` is highly imbalanced (85.7%)	Imbalance
`Asset Category` is highly imbalanced (82.8%)	Imbalance
`Waste Stream` is highly imbalanced (89.3%)	Imbalance
`Waste Type` is highly imbalanced (83.0%)	Imbalance
`UOM for Volume` is highly imbalanced (79.8%)	Imbalance
`Tons Derived` is highly imbalanced (74.6%)	Imbalance
`Compactor` has 29161 (38.5%) missing values	Missing
`Charge Sub-Type` has 52372 (69.2%) missing values	Missing
`Recycle Tons` is highly skewed (γ1 = 22.47100786)	Skewed
`Trash Tons` has 1772 (2.3%) zeros	Zeros
`Recycle Tons` has 74338 (98.2%) zeros	Zeros

Reproduction

Analysis started	2023-12-20 11:45:43.777415
Analysis finished	2023-12-20 11:46:31.514048
Duration	47.74 seconds
Software version	ydata-profiling vv4.6.3
Download configuration	config.json

Location ID
Categorical

HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

110	7573
118	6108
108	5691
122	4353
124	4080
Other values (26)	47865

Length

Max length	8
Median length	3
Mean length	3.1186996
Min length	3

Characters and Unicode

Total characters	235992
Distinct characters	22
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	101
2nd row	101
3rd row	101
4th row	101
5th row	101

Common Values

Value	Count	Frequency (%)
110	7573	10.0%
118	6108	8.1%
108	5691	7.5%
122	4353	5.8%
124	4080	5.4%
103	3768	5.0%
119	3617	4.8%
116	3481	4.6%
117	3297	4.4%
104	3186	4.2%
Other values (21)	30516	40.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
110	7573	9.6%
118	6108	7.8%
108	5691	7.2%
122	4353	5.5%
124	4080	5.2%
103	3768	4.8%
119	3617	4.6%
116	3481	4.4%
117	3297	4.2%
104	3186	4.1%
Other values (24)	33452	42.6%

Most occurring characters

Value	Count	Frequency (%)
1	115943	49.1%
0	31815	13.5%
2	24092	10.2%
8	11799	5.0%
9	11413	4.8%
4	8939	3.8%
3	7141	3.0%
5	5658	2.4%
6	5355	2.3%
7	4854	2.1%
Other values (12)	8983	3.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	227009	96.2%
Uppercase Letter	6043	2.6%
Space Separator	2936	1.2%
Dash Punctuation	4	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	115943	51.1%
0	31815	14.0%
2	24092	10.6%
8	11799	5.2%
9	11413	5.0%
4	8939	3.9%
3	7141	3.1%
5	5658	2.5%
6	5355	2.4%
7	4854	2.1%

Uppercase Letter

Value	Count	Frequency (%)
C	2932	48.5%
D	2928	48.5%
R	173	2.9%
S	4	0.1%
G	1	< 0.1%
J	1	< 0.1%
T	1	< 0.1%
E	1	< 0.1%
M	1	< 0.1%
P	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	2936	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	229949	97.4%
Latin	6043	2.6%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	115943	50.4%
0	31815	13.8%
2	24092	10.5%
8	11799	5.1%
9	11413	5.0%
4	8939	3.9%
3	7141	3.1%
5	5658	2.5%
6	5355	2.3%
7	4854	2.1%
Other values (2)	2940	1.3%

Latin

Value	Count	Frequency (%)
C	2932	48.5%
D	2928	48.5%
R	173	2.9%
S	4	0.1%
G	1	< 0.1%
J	1	< 0.1%
T	1	< 0.1%
E	1	< 0.1%
M	1	< 0.1%
P	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	235992	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	115943	49.1%
0	31815	13.5%
2	24092	10.2%
8	11799	5.0%
9	11413	4.8%
4	8939	3.8%
3	7141	3.0%
5	5658	2.4%
6	5355	2.3%
7	4854	2.1%
Other values (12)	8983	3.8%

Invoice Number
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20220622

Minimum	20220100
Maximum	20221200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	20220100
5-th percentile	20220100
Q1	20220300
median	20220600
Q3	20220900
95-th percentile	20221200
Maximum	20221200
Range	1100
Interquartile range (IQR)	600

Descriptive statistics

Standard deviation	338.37986
Coefficient of variation (CV)	1.6734394 × 10^-5
Kurtosis	-1.1751507
Mean	20220622
Median Absolute Deviation (MAD)	300
Skewness	0.045384881
Sum	1.5300945 × 10¹²
Variance	114500.93
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
20220900	8377	11.1%
20220100	7577	10.0%
20220500	7166	9.5%
20220400	6907	9.1%
20220700	6633	8.8%
20220200	6306	8.3%
20220300	6039	8.0%
20220800	5838	7.7%
20220600	5552	7.3%
20221000	5488	7.3%
Other values (2)	9787	12.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20220100	7577	10.0%
20220200	6306	8.3%
20220300	6039	8.0%
20220400	6907	9.1%
20220500	7166	9.5%
20220600	5552	7.3%
20220700	6633	8.8%
20220800	5838	7.7%
20220900	8377	11.1%
20221000	5488	7.3%

Value	Count	Frequency (%)
20221200	4807	6.4%
20221100	4980	6.6%
20221000	5488	7.3%
20220900	8377	11.1%
20220800	5838	7.7%
20220700	6633	8.8%
20220600	5552	7.3%
20220500	7166	9.5%
20220400	6907	9.1%
20220300	6039	8.0%

Account
Text

Distinct	199
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	7.5 MiB

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	832370
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	800-0303937
2nd row	800-0303937
3rd row	800-0303937
4th row	800-0303937
5th row	800-0303937

Value	Count	Frequency (%)
690-8001477	5472	7.2%
625-8109512	5126	6.8%
535-8004902	4248	5.6%
625-8109508	3960	5.2%
687-8001871	3408	4.5%
625-0125391	3324	4.4%
615-8000411	3072	4.1%
853-0136012	2928	3.9%
535-8004903	2592	3.4%
794-8016671	1872	2.5%
Other values (189)	39668	52.4%

Most occurring characters

Value	Count	Frequency (%)
0	169438	20.4%
8	98674	11.9%
1	91004	10.9%
5	86798	10.4%
-	75670	9.1%
6	64120	7.7%
2	61467	7.4%
9	51714	6.2%
3	49951	6.0%
4	45591	5.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	756700	90.9%
Dash Punctuation	75670	9.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	169438	22.4%
8	98674	13.0%
1	91004	12.0%
5	86798	11.5%
6	64120	8.5%
2	61467	8.1%
9	51714	6.8%
3	49951	6.6%
4	45591	6.0%
7	37943	5.0%

Dash Punctuation

Value	Count	Frequency (%)
-	75670	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	832370	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	169438	20.4%
8	98674	11.9%
1	91004	10.9%
5	86798	10.4%
-	75670	9.1%
6	64120	7.7%
2	61467	7.4%
9	51714	6.2%
3	49951	6.0%
4	45591	5.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	832370	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	169438	20.4%
8	98674	11.9%
1	91004	10.9%
5	86798	10.4%
-	75670	9.1%
6	64120	7.7%
2	61467	7.4%
9	51714	6.2%
3	49951	6.0%
4	45591	5.5%

Asset ID
Text

Distinct	209
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	8.1 MiB

Length

Max length	20
Median length	20
Mean length	20
Min length	20

Characters and Unicode

Total characters	1513400
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	800-0303937-00001-01
2nd row	800-0303937-00001-01
3rd row	800-0303937-00001-01
4th row	800-0303937-00001-01
5th row	800-0303937-00001-01

Value	Count	Frequency (%)
690-8001477-00001-02	5472	7.2%
625-8109512-00001-01	5126	6.8%
535-8004902-00001-02	4248	5.6%
625-8109508-00001-01	3960	5.2%
687-8001871-00001-01	3408	4.5%
625-0125391-00001-01	3324	4.4%
615-8000411-00001-01	3072	4.1%
853-0136012-00001-01	2928	3.9%
535-8004903-00001-01	2592	3.4%
794-8016671-00001-01	1872	2.5%
Other values (199)	39668	52.4%

Most occurring characters

Value	Count	Frequency (%)
0	547788	36.2%
1	227222	15.0%
-	227010	15.0%
8	98674	6.5%
5	86798	5.7%
2	75209	5.0%
6	64120	4.2%
9	51714	3.4%
3	51331	3.4%
4	45591	3.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1286390	85.0%
Dash Punctuation	227010	15.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	547788	42.6%
1	227222	17.7%
8	98674	7.7%
5	86798	6.7%
2	75209	5.8%
6	64120	5.0%
9	51714	4.0%
3	51331	4.0%
4	45591	3.5%
7	37943	2.9%

Dash Punctuation

Value	Count	Frequency (%)
-	227010	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1513400	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	547788	36.2%
1	227222	15.0%
-	227010	15.0%
8	98674	6.5%
5	86798	5.7%
2	75209	5.0%
6	64120	4.2%
9	51714	3.4%
3	51331	3.4%
4	45591	3.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1513400	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	547788	36.2%
1	227222	15.0%
-	227010	15.0%
8	98674	6.5%
5	86798	5.7%
2	75209	5.0%
6	64120	4.2%
9	51714	3.4%
3	51331	3.4%
4	45591	3.0%

Location
Text

Distinct	186
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	8.6 MiB

Length

Max length	30
Median length	27
Mean length	25.993947
Min length	5

Characters and Unicode

Total characters	1966962
Distinct characters	39
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	FLOOR & DECOR 101 30YD CLEANUP
2nd row	FLOOR & DECOR 101 30YD CLEANUP
3rd row	FLOOR & DECOR 101 30YD CLEANUP
4th row	FLOOR & DECOR 101 30YD CLEANUP
5th row	FLOOR & DECOR 101 30YD CLEANUP

Value	Count	Frequency (%)
floor	74740	17.1%
decor	74307	17.0%
	71234	16.3%
40yd	64259	14.7%
comp	46254	10.6%
110	7573	1.7%
118	6108	1.4%
108	5691	1.3%
122	4352	1.0%
124	4075	0.9%
Other values (81)	78454	18.0%

Most occurring characters

Value	Count	Frequency (%)
	361377	18.4%
O	275480	14.0%
D	157917	8.0%
R	154233	7.8%
C	133252	6.8%
1	114526	5.8%
0	98323	5.0%
E	82575	4.2%
L	80033	4.1%
F	76577	3.9%
Other values (29)	432669	22.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1164059	59.2%
Decimal Number	366298	18.6%
Space Separator	361377	18.4%
Other Punctuation	74955	3.8%
Dash Punctuation	273	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	275480	23.7%
D	157917	13.6%
R	154233	13.2%
C	133252	11.4%
E	82575	7.1%
L	80033	6.9%
F	76577	6.6%
Y	72653	6.2%
P	52404	4.5%
M	50527	4.3%
Other values (16)	28408	2.4%

Decimal Number

Value	Count	Frequency (%)
1	114526	31.3%
0	98323	26.8%
4	75765	20.7%
2	27119	7.4%
8	12565	3.4%
9	11413	3.1%
3	10337	2.8%
6	6861	1.9%
7	4854	1.3%
5	4535	1.2%

Space Separator

Value	Count	Frequency (%)
	361377	100.0%

Other Punctuation

Value	Count	Frequency (%)
&	74955	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	273	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1164059	59.2%
Common	802903	40.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	275480	23.7%
D	157917	13.6%
R	154233	13.2%
C	133252	11.4%
E	82575	7.1%
L	80033	6.9%
F	76577	6.6%
Y	72653	6.2%
P	52404	4.5%
M	50527	4.3%
Other values (16)	28408	2.4%

Common

Value	Count	Frequency (%)
	361377	45.0%
1	114526	14.3%
0	98323	12.2%
4	75765	9.4%
&	74955	9.3%
2	27119	3.4%
8	12565	1.6%
9	11413	1.4%
3	10337	1.3%
6	6861	0.9%
Other values (3)	9662	1.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1966529	> 99.9%
None	433	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	361377	18.4%
O	275480	14.0%
D	157917	8.0%
R	154233	7.8%
C	133252	6.8%
1	114526	5.8%
0	98323	5.0%
E	82575	4.2%
L	80033	4.1%
F	76577	3.9%
Other values (28)	432236	22.0%

None

Value	Count	Frequency (%)
É	433	100.0%

Address
Categorical

HIGH CORRELATION

Distinct	42
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.1 MiB

3113 E COLONIAL DR	7573
1980 E COUNTY LINE RD	6108
1914 W ATLANTIC BLVD	5691
2525 NW 82ND AVE	4353
4 WESTSIDE SHOPPING CENTER	4075
Other values (37)	47870

Length

Max length	30
Median length	27
Mean length	19.351645
Min length	14

Characters and Unicode

Total characters	1464339
Distinct characters	34
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	1690 NORTHEAST EXPY NE
2nd row	1690 NORTHEAST EXPY NE
3rd row	1690 NORTHEAST EXPY NE
4th row	1690 NORTHEAST EXPY NE
5th row	1690 NORTHEAST EXPY NE

Common Values

Value	Count	Frequency (%)
3113 E COLONIAL DR	7573	10.0%
1980 E COUNTY LINE RD	6108	8.1%
1914 W ATLANTIC BLVD	5691	7.5%
2525 NW 82ND AVE	4353	5.8%
4 WESTSIDE SHOPPING CENTER	4075	5.4%
8102 BLANDING BLVD	3768	5.0%
125 NW LOOP 410	3617	4.8%
21760 US HIGHWAY 19 N	3438	4.5%
7350 W 52ND AVE	3297	4.4%
2350 ALBERTA DR	3186	4.2%
Other values (32)	30564	40.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
w	21117	6.9%
e	17290	5.7%
dr	17278	5.7%
rd	11311	3.7%
nw	9844	3.2%
blvd	9459	3.1%
pkwy	8433	2.8%
ave	7661	2.5%
3113	7573	2.5%
colonial	7573	2.5%
Other values (94)	186738	61.4%

Most occurring characters

Value	Count	Frequency (%)
	304277	20.8%
N	78774	5.4%
E	78679	5.4%
1	78194	5.3%
L	67640	4.6%
R	64947	4.4%
D	61528	4.2%
0	60227	4.1%
A	59560	4.1%
W	52756	3.6%
Other values (24)	557757	38.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	827697	56.5%
Decimal Number	332365	22.7%
Space Separator	304277	20.8%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	78774	9.5%
E	78679	9.5%
L	67640	8.2%
R	64947	7.8%
D	61528	7.4%
A	59560	7.2%
W	52756	6.4%
T	49777	6.0%
O	46116	5.6%
I	41576	5.0%
Other values (13)	226344	27.3%

Decimal Number

Value	Count	Frequency (%)
1	78194	23.5%
0	60227	18.1%
2	42891	12.9%
5	41852	12.6%
8	25932	7.8%
4	23275	7.0%
3	23229	7.0%
9	19327	5.8%
7	12475	3.8%
6	4963	1.5%

Space Separator

Value	Count	Frequency (%)
	304277	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	827697	56.5%
Common	636642	43.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	78774	9.5%
E	78679	9.5%
L	67640	8.2%
R	64947	7.8%
D	61528	7.4%
A	59560	7.2%
W	52756	6.4%
T	49777	6.0%
O	46116	5.6%
I	41576	5.0%
Other values (13)	226344	27.3%

Common

Value	Count	Frequency (%)
	304277	47.8%
1	78194	12.3%
0	60227	9.5%
2	42891	6.7%
5	41852	6.6%
8	25932	4.1%
4	23275	3.7%
3	23229	3.6%
9	19327	3.0%
7	12475	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1464339	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	304277	20.8%
N	78774	5.4%
E	78679	5.4%
1	78194	5.3%
L	67640	4.6%
R	64947	4.4%
D	61528	4.2%
0	60227	4.1%
A	59560	4.1%
W	52756	3.6%
Other values (24)	557757	38.1%

City
Categorical

HIGH CORRELATION

Distinct	33
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.3 MiB

ORLANDO	7560
HIGHLANDS RANCH	6108
HOUSTON	5707
POMPANO BEACH	5691
DORAL	4353
Other values (28)	46251

Length

Max length	15
Median length	12
Mean length	8.4003304
Min length	5

Characters and Unicode

Total characters	635653
Distinct characters	25
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	BROOKHAVEN
2nd row	BROOKHAVEN
3rd row	BROOKHAVEN
4th row	BROOKHAVEN
5th row	BROOKHAVEN

Common Values

Value	Count	Frequency (%)
ORLANDO	7560	10.0%
HIGHLANDS RANCH	6108	8.1%
HOUSTON	5707	7.5%
POMPANO BEACH	5691	7.5%
DORAL	4353	5.8%
GRETNA	4075	5.4%
JACKSONVILLE	3768	5.0%
SAN ANTONIO	3617	4.8%
CLEARWATER	3481	4.6%
ARVADA	3297	4.4%
Other values (23)	28013	37.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
orlando	7560	8.3%
ranch	6108	6.7%
highlands	6108	6.7%
houston	5707	6.3%
beach	5692	6.2%
pompano	5691	6.2%
doral	4353	4.8%
gretna	4075	4.5%
jacksonville	3768	4.1%
antonio	3617	4.0%
Other values (27)	38421	42.2%

Most occurring characters

Value	Count	Frequency (%)
A	94288	14.8%
N	75562	11.9%
O	68434	10.8%
L	48272	7.6%
R	41614	6.5%
E	38474	6.1%
H	34221	5.4%
D	31217	4.9%
S	29534	4.6%
T	28271	4.4%
Other values (15)	145766	22.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	620223	97.6%
Space Separator	15430	2.4%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	94288	15.2%
N	75562	12.2%
O	68434	11.0%
L	48272	7.8%
R	41614	6.7%
E	38474	6.2%
H	34221	5.5%
D	31217	5.0%
S	29534	4.8%
T	28271	4.6%
Other values (14)	130336	21.0%

Space Separator

Value	Count	Frequency (%)
	15430	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	620223	97.6%
Common	15430	2.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	94288	15.2%
N	75562	12.2%
O	68434	11.0%
L	48272	7.8%
R	41614	6.7%
E	38474	6.2%
H	34221	5.5%
D	31217	5.0%
S	29534	4.8%
T	28271	4.6%
Other values (14)	130336	21.0%

Common

Value	Count	Frequency (%)
	15430	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	635653	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	94288	14.8%
N	75562	11.9%
O	68434	10.8%
L	48272	7.6%
R	41614	6.5%
E	38474	6.1%
H	34221	5.4%
D	31217	4.9%
S	29534	4.6%
T	28271	4.4%
Other values (15)	145766	22.9%

State
Categorical

HIGH CORRELATION

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

FL	26532
TX	22433
CO	9405
AZ	4399
LA	4075
Other values (6)	8826

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	151340
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	GA
2nd row	GA
3rd row	GA
4th row	GA
5th row	GA

Common Values

Value	Count	Frequency (%)
FL	26532	35.1%
TX	22433	29.6%
CO	9405	12.4%
AZ	4399	5.8%
LA	4075	5.4%
GA	3140	4.1%
NV	2481	3.3%
CA	1691	2.2%
OH	1507	2.0%
TN	6	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
fl	26532	35.1%
tx	22433	29.6%
co	9405	12.4%
az	4399	5.8%
la	4075	5.4%
ga	3140	4.1%
nv	2481	3.3%
ca	1691	2.2%
oh	1507	2.0%
tn	6	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
L	30607	20.2%
F	26532	17.5%
T	22439	14.8%
X	22433	14.8%
A	13305	8.8%
C	11096	7.3%
O	10912	7.2%
Z	4399	2.9%
G	3140	2.1%
N	2487	1.6%
Other values (4)	3990	2.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	151340	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
L	30607	20.2%
F	26532	17.5%
T	22439	14.8%
X	22433	14.8%
A	13305	8.8%
C	11096	7.3%
O	10912	7.2%
Z	4399	2.9%
G	3140	2.1%
N	2487	1.6%
Other values (4)	3990	2.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	151340	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
L	30607	20.2%
F	26532	17.5%
T	22439	14.8%
X	22433	14.8%
A	13305	8.8%
C	11096	7.3%
O	10912	7.2%
Z	4399	2.9%
G	3140	2.1%
N	2487	1.6%
Other values (4)	3990	2.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	151340	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
L	30607	20.2%
F	26532	17.5%
T	22439	14.8%
X	22433	14.8%
A	13305	8.8%
C	11096	7.3%
O	10912	7.2%
Z	4399	2.9%
G	3140	2.1%
N	2487	1.6%
Other values (4)	3990	2.6%

Zip Code
Real number (ℝ)

Distinct	33
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	60175.899

Minimum	30144
Maximum	92860
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	30144
5-th percentile	32244
Q1	33069
median	75229
Q3	78759
95-th percentile	89014
Maximum	92860
Range	62716
Interquartile range (IQR)	45690

Descriptive statistics

Standard deviation	22987.141
Coefficient of variation (CV)	0.38199912
Kurtosis	-1.7744059
Mean	60175.899
Median Absolute Deviation (MAD)	10079
Skewness	-0.27261109
Sum	4.5535103 × 10⁹
Variance	5.2840863 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
32803	7573	10.0%
80126	6108	8.1%
33069	5691	7.5%
33122	4353	5.8%
70053	4075	5.4%
32244	3768	5.0%
78216	3617	4.8%
33765	3481	4.6%
80002	3297	4.4%
75229	3186	4.2%
Other values (23)	30521	40.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
30144	1874	2.5%
30260	571	0.8%
30329	695	0.9%
32244	3768	5.0%
32803	7573	10.0%
33069	5691	7.5%
33122	4353	5.8%
33183	5	< 0.1%
33426	1	< 0.1%
33619	1669	2.2%

Value	Count	Frequency (%)
92860	1691	2.2%
89014	2481	3.3%
85308	2709	3.6%
85283	1668	2.2%
85038	9	< 0.1%
80126	6108	8.1%
80002	3297	4.4%
78759	2783	3.7%
78216	3617	4.8%
77523	2928	3.9%

Container Type
Categorical

HIGH CORRELATION IMBALANCE

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

RO	71986
SC	1743
FL	792
FR	756
HP	389

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	151340
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RO
2nd row	RO
3rd row	RO
4th row	RO
5th row	RO

Common Values

Value	Count	Frequency (%)
RO	71986	95.1%
SC	1743	2.3%
FL	792	1.0%
FR	756	1.0%
HP	389	0.5%
IR	4	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ro	71986	95.1%
sc	1743	2.3%
fl	792	1.0%
fr	756	1.0%
hp	389	0.5%
ir	4	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
R	72746	48.1%
O	71986	47.6%
S	1743	1.2%
C	1743	1.2%
F	1548	1.0%
L	792	0.5%
H	389	0.3%
P	389	0.3%
I	4	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	151340	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	72746	48.1%
O	71986	47.6%
S	1743	1.2%
C	1743	1.2%
F	1548	1.0%
L	792	0.5%
H	389	0.3%
P	389	0.3%
I	4	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	151340	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	72746	48.1%
O	71986	47.6%
S	1743	1.2%
C	1743	1.2%
F	1548	1.0%
L	792	0.5%
H	389	0.3%
P	389	0.3%
I	4	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	151340	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
R	72746	48.1%
O	71986	47.6%
S	1743	1.2%
C	1743	1.2%
F	1548	1.0%
L	792	0.5%
H	389	0.3%
P	389	0.3%
I	4	< 0.1%

Container Size
Real number (ℝ)

HIGH CORRELATION

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.446121

Minimum	0
Maximum	42
Zeros	389
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	30
Q1	40
median	40
Q3	40
95-th percentile	40
Maximum	42
Range	42
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	6.082431
Coefficient of variation (CV)	0.15820662
Kurtosis	22.27431
Mean	38.446121
Median Absolute Deviation (MAD)	0
Skewness	-4.6442891
Sum	2909218
Variance	36.995967
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
40	66616	88.0%
30	3895	5.1%
42	1512	2.0%
36	1272	1.7%
8	756	1.0%
4	564	0.7%
20	438	0.6%
0	389	0.5%
6	228	0.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	389	0.5%
4	564	0.7%
6	228	0.3%
8	756	1.0%
20	438	0.6%
30	3895	5.1%
36	1272	1.7%
40	66616	88.0%
42	1512	2.0%

Value	Count	Frequency (%)
42	1512	2.0%
40	66616	88.0%
36	1272	1.7%
30	3895	5.1%
20	438	0.6%
8	756	1.0%
6	228	0.3%
4	564	0.7%
0	389	0.5%

Compactor
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	29161
Missing (%)	38.5%
Memory size	6.3 MiB

C	46509

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	46509
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	C
2nd row	C
3rd row	C
4th row	C
5th row	C

Common Values

Value	Count	Frequency (%)
C	46509	61.5%
(Missing)	29161	38.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
c	46509	100.0%

Most occurring characters

Value	Count	Frequency (%)
C	46509	100.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	46509	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	46509	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	46509	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	46509	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	46509	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	46509	100.0%

Asset Type
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.4 MiB

PERMANENT	56614
TEMPORARY	19056

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	681030
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	TEMPORARY
2nd row	TEMPORARY
3rd row	TEMPORARY
4th row	TEMPORARY
5th row	TEMPORARY

Common Values

Value	Count	Frequency (%)
PERMANENT	56614	74.8%
TEMPORARY	19056	25.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
permanent	56614	74.8%
temporary	19056	25.2%

Most occurring characters

Value	Count	Frequency (%)
E	132284	19.4%
N	113228	16.6%
R	94726	13.9%
P	75670	11.1%
M	75670	11.1%
A	75670	11.1%
T	75670	11.1%
O	19056	2.8%
Y	19056	2.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	681030	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	132284	19.4%
N	113228	16.6%
R	94726	13.9%
P	75670	11.1%
M	75670	11.1%
A	75670	11.1%
T	75670	11.1%
O	19056	2.8%
Y	19056	2.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	681030	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	132284	19.4%
N	113228	16.6%
R	94726	13.9%
P	75670	11.1%
M	75670	11.1%
A	75670	11.1%
T	75670	11.1%
O	19056	2.8%
Y	19056	2.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	681030	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	132284	19.4%
N	113228	16.6%
R	94726	13.9%
P	75670	11.1%
M	75670	11.1%
A	75670	11.1%
T	75670	11.1%
O	19056	2.8%
Y	19056	2.8%

Asset Category
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.4 MiB

Industrial	73733
Commercial	1937

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	756700
Distinct characters	15
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Industrial
2nd row	Industrial
3rd row	Industrial
4th row	Industrial
5th row	Industrial

Common Values

Value	Count	Frequency (%)
Industrial	73733	97.4%
Commercial	1937	2.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
industrial	73733	97.4%
commercial	1937	2.6%

Most occurring characters

Value	Count	Frequency (%)
r	75670	10.0%
i	75670	10.0%
a	75670	10.0%
l	75670	10.0%
I	73733	9.7%
n	73733	9.7%
d	73733	9.7%
u	73733	9.7%
s	73733	9.7%
t	73733	9.7%
Other values (5)	11622	1.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	681030	90.0%
Uppercase Letter	75670	10.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	75670	11.1%
i	75670	11.1%
a	75670	11.1%
l	75670	11.1%
n	73733	10.8%
d	73733	10.8%
u	73733	10.8%
s	73733	10.8%
t	73733	10.8%
m	3874	0.6%
Other values (3)	5811	0.9%

Uppercase Letter

Value	Count	Frequency (%)
I	73733	97.4%
C	1937	2.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	756700	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	75670	10.0%
i	75670	10.0%
a	75670	10.0%
l	75670	10.0%
I	73733	9.7%
n	73733	9.7%
d	73733	9.7%
u	73733	9.7%
s	73733	9.7%
t	73733	9.7%
Other values (5)	11622	1.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	756700	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	75670	10.0%
i	75670	10.0%
a	75670	10.0%
l	75670	10.0%
I	73733	9.7%
n	73733	9.7%
d	73733	9.7%
u	73733	9.7%
s	73733	9.7%
t	73733	9.7%
Other values (5)	11622	1.5%

Waste Stream
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.1 MiB

Trash	74605
Recycle	1065

Length

Max length	7
Median length	5
Mean length	5.0281485
Min length	5

Characters and Unicode

Total characters	380480
Distinct characters	10
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Trash
2nd row	Trash
3rd row	Trash
4th row	Trash
5th row	Trash

Common Values

Value	Count	Frequency (%)
Trash	74605	98.6%
Recycle	1065	1.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
trash	74605	98.6%
recycle	1065	1.4%

Most occurring characters

Value	Count	Frequency (%)
T	74605	19.6%
r	74605	19.6%
a	74605	19.6%
s	74605	19.6%
h	74605	19.6%
e	2130	0.6%
c	2130	0.6%
R	1065	0.3%
y	1065	0.3%
l	1065	0.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	304810	80.1%
Uppercase Letter	75670	19.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	74605	24.5%
a	74605	24.5%
s	74605	24.5%
h	74605	24.5%
e	2130	0.7%
c	2130	0.7%
y	1065	0.3%
l	1065	0.3%

Uppercase Letter

Value	Count	Frequency (%)
T	74605	98.6%
R	1065	1.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	380480	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	74605	19.6%
r	74605	19.6%
a	74605	19.6%
s	74605	19.6%
h	74605	19.6%
e	2130	0.6%
c	2130	0.6%
R	1065	0.3%
y	1065	0.3%
l	1065	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	380480	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	74605	19.6%
r	74605	19.6%
a	74605	19.6%
s	74605	19.6%
h	74605	19.6%
e	2130	0.6%
c	2130	0.6%
R	1065	0.3%
y	1065	0.3%
l	1065	0.3%

Waste Type
Categorical

HIGH CORRELATION IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.1 MiB

NONE	70973
CONSTRUCTION/DEMOLITION DEBRIS	3664
SINGLE STREAM RECYCLING	756
WOOD	266
METAL	11

Length

Max length	30
Median length	4
Mean length	5.4489097
Min length	4

Characters and Unicode

Total characters	412319
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NONE
2nd row	NONE
3rd row	NONE
4th row	NONE
5th row	NONE

Common Values

Value	Count	Frequency (%)
NONE	70973	93.8%
CONSTRUCTION/DEMOLITION DEBRIS	3664	4.8%
SINGLE STREAM RECYCLING	756	1.0%
WOOD	266	0.4%
METAL	11	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
none	70973	87.8%
construction/demolition	3664	4.5%
debris	3664	4.5%
single	756	0.9%
stream	756	0.9%
recycling	756	0.9%
wood	266	0.3%
metal	11	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
N	154450	37.5%
O	86161	20.9%
E	80580	19.5%
I	16168	3.9%
T	11759	2.9%
C	8840	2.1%
S	8840	2.1%
R	8840	2.1%
D	7594	1.8%
L	5187	1.3%
Other values (9)	23900	5.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	403479	97.9%
Space Separator	5176	1.3%
Other Punctuation	3664	0.9%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	154450	38.3%
O	86161	21.4%
E	80580	20.0%
I	16168	4.0%
T	11759	2.9%
C	8840	2.2%
S	8840	2.2%
R	8840	2.2%
D	7594	1.9%
L	5187	1.3%
Other values (7)	15060	3.7%

Space Separator

Value	Count	Frequency (%)
	5176	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	3664	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	403479	97.9%
Common	8840	2.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	154450	38.3%
O	86161	21.4%
E	80580	20.0%
I	16168	4.0%
T	11759	2.9%
C	8840	2.2%
S	8840	2.2%
R	8840	2.2%
D	7594	1.9%
L	5187	1.3%
Other values (7)	15060	3.7%

Common

Value	Count	Frequency (%)
	5176	58.6%
/	3664	41.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	412319	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	154450	37.5%
O	86161	20.9%
E	80580	19.5%
I	16168	3.9%
T	11759	2.9%
C	8840	2.1%
S	8840	2.1%
R	8840	2.1%
D	7594	1.8%
L	5187	1.3%
Other values (9)	23900	5.8%

Report Date
Date

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Minimum	2022-01-01 00:00:00
Maximum	2022-12-01 00:00:00

Histogram

Histogram with fixed size bins (bins=12)

Charge Date
Date

Distinct	392
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Minimum	2021-08-12 00:00:00
Maximum	2023-01-01 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Charge Amount
Text

Distinct	3436
Distinct (%)	4.5%
Missing	0
Missing (%)	0.0%
Memory size	7.3 MiB

Length

Max length	11
Median length	8
Mean length	7.5566275
Min length	6

Characters and Unicode

Total characters	571810
Distinct characters	16
Distinct categories	6 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	364 ?
Unique (%)	0.5%

Sample

1st row	$77.25
2nd row	$77.25
3rd row	$77.25
4th row	$77.25
5th row	$77.25

Value	Count	Frequency (%)
0.00	2814	3.7%
152.77	2208	2.9%
280.68	1608	2.1%
79.57	1519	2.0%
290.24	1332	1.8%
569.22	1276	1.7%
185.66	1225	1.6%
602.50	1104	1.5%
330.63	1085	1.4%
550.75	957	1.3%
Other values (3365)	60542	80.0%

Most occurring characters

Value	Count	Frequency (%)
$	75670	13.2%
.	75670	13.2%
	74967	13.1%
2	45465	8.0%
0	43560	7.6%
1	43151	7.5%
5	35933	6.3%
6	31965	5.6%
7	30061	5.3%
8	29540	5.2%
Other values (6)	85828	15.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	342637	59.9%
Other Punctuation	77130	13.5%
Currency Symbol	75670	13.2%
Space Separator	74967	13.1%
Open Punctuation	703	0.1%
Close Punctuation	703	0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	45465	13.3%
0	43560	12.7%
1	43151	12.6%
5	35933	10.5%
6	31965	9.3%
7	30061	8.8%
8	29540	8.6%
3	28989	8.5%
4	27367	8.0%
9	26606	7.8%

Other Punctuation

Value	Count	Frequency (%)
.	75670	98.1%
,	1460	1.9%

Currency Symbol

Value	Count	Frequency (%)
$	75670	100.0%

Space Separator

Value	Count	Frequency (%)
	74967	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	703	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	703	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	571810	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
$	75670	13.2%
.	75670	13.2%
	74967	13.1%
2	45465	8.0%
0	43560	7.6%
1	43151	7.5%
5	35933	6.3%
6	31965	5.6%
7	30061	5.3%
8	29540	5.2%
Other values (6)	85828	15.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	571810	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
$	75670	13.2%
.	75670	13.2%
	74967	13.1%
2	45465	8.0%
0	43560	7.6%
1	43151	7.5%
5	35933	6.3%
6	31965	5.6%
7	30061	5.3%
8	29540	5.2%
Other values (6)	85828	15.0%

Charge Code Desc.
Categorical

HIGH CORRELATION

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.5 MiB

DISPOSAL CHARGE	26206
HAUL	24424
FEE (FRANCHISE)	4271
CONTAINER/COMPACTOR RENTAL	4228
STATE TAX	3890
Other values (23)	12651

Length

Max length	28
Median length	26
Mean length	11.487023
Min length	3

Characters and Unicode

Total characters	869223
Distinct characters	28
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	CONTAINER/COMPACTOR RENTAL
2nd row	CONTAINER/COMPACTOR RENTAL
3rd row	CONTAINER/COMPACTOR RENTAL
4th row	CONTAINER/COMPACTOR RENTAL
5th row	CONTAINER/COMPACTOR RENTAL

Common Values

Value	Count	Frequency (%)
DISPOSAL CHARGE	26206	34.6%
HAUL	24424	32.3%
FEE (FRANCHISE)	4271	5.6%
CONTAINER/COMPACTOR RENTAL	4228	5.6%
STATE TAX	3890	5.1%
CITY TAX	2243	3.0%
SERVICE ATTEMPT	2049	2.7%
COUNTY TAX	1993	2.6%
MTA TAX	1804	2.4%
HAUL/MONTHLY STANDARD SVC	992	1.3%
Other values (18)	3570	4.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
charge	26390	20.4%
disposal	26206	20.2%
haul	24424	18.8%
tax	10215	7.9%
fee	6010	4.6%
franchise	4271	3.3%
container/compactor	4236	3.3%
rental	4228	3.3%
state	3890	3.0%
city	2243	1.7%
Other values (31)	17483	13.5%

Most occurring characters

Value	Count	Frequency (%)
A	118892	13.7%
S	67993	7.8%
E	65547	7.5%
L	59634	6.9%
H	58053	6.7%
	53926	6.2%
C	52389	6.0%
T	49417	5.7%
R	49034	5.6%
I	44380	5.1%
Other values (18)	249958	28.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	797989	91.8%
Space Separator	53926	6.2%
Close Punctuation	6010	0.7%
Open Punctuation	6010	0.7%
Other Punctuation	5288	0.6%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	118892	14.9%
S	67993	8.5%
E	65547	8.2%
L	59634	7.5%
H	58053	7.3%
C	52389	6.6%
T	49417	6.2%
R	49034	6.1%
I	44380	5.6%
O	43322	5.4%
Other values (14)	189328	23.7%

Space Separator

Value	Count	Frequency (%)
	53926	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	6010	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	6010	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	5288	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	797989	91.8%
Common	71234	8.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	118892	14.9%
S	67993	8.5%
E	65547	8.2%
L	59634	7.5%
H	58053	7.3%
C	52389	6.6%
T	49417	6.2%
R	49034	6.1%
I	44380	5.6%
O	43322	5.4%
Other values (14)	189328	23.7%

Common

Value	Count	Frequency (%)
	53926	75.7%
)	6010	8.4%
(	6010	8.4%
/	5288	7.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	869223	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	118892	13.7%
S	67993	7.8%
E	65547	7.5%
L	59634	6.9%
H	58053	6.7%
	53926	6.2%
C	52389	6.0%
T	49417	5.7%
R	49034	5.6%
I	44380	5.1%
Other values (18)	249958	28.8%

From Date
Date

Distinct	399
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Minimum	2021-08-12 00:00:00
Maximum	2023-01-01 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

To Date
Date

Distinct	393
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Minimum	2021-08-12 00:00:00
Maximum	2023-01-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Quantity
Real number (ℝ)

HIGH CORRELATION

Distinct	945
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.8239264

Minimum	0.01
Maximum	40
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0.01
5-th percentile	1
Q1	1
median	1
Q3	3.57
95-th percentile	9.18
Maximum	40
Range	39.99
Interquartile range (IQR)	2.57

Descriptive statistics

Standard deviation	3.9464495
Coefficient of variation (CV)	1.3975044
Kurtosis	37.643446
Mean	2.8239264
Median Absolute Deviation (MAD)	0
Skewness	5.0206317
Sum	213686.51
Variance	15.574463
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	46517	61.5%
4	419	0.6%
40	299	0.4%
30	280	0.4%
4.18	150	0.2%
2.34	129	0.2%
9.18	124	0.2%
3.69	122	0.2%
3.11	120	0.2%
2.8	119	0.2%
Other values (935)	27391	36.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	41	0.1%
0.04	12	< 0.1%
0.06	1	< 0.1%
0.07	23	< 0.1%
0.09	3	< 0.1%
0.1	21	< 0.1%
0.15	12	< 0.1%
0.16	12	< 0.1%
0.17	3	< 0.1%
0.18	3	< 0.1%

Value	Count	Frequency (%)
40	299	0.4%
30	280	0.4%
21.38	12	< 0.1%
19.18	11	< 0.1%
16.3	36	< 0.1%
15.85	12	< 0.1%
15.77	24	< 0.1%
14.88	12	< 0.1%
14.84	12	< 0.1%
14.42	12	< 0.1%

Unit of Measure
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

EA	45689
TN	29390
YD	591

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	151340
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	EA
2nd row	EA
3rd row	EA
4th row	EA
5th row	EA

Common Values

Value	Count	Frequency (%)
EA	45689	60.4%
TN	29390	38.8%
YD	591	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ea	45689	60.4%
tn	29390	38.8%
yd	591	0.8%

Most occurring characters

Value	Count	Frequency (%)
E	45689	30.2%
A	45689	30.2%
T	29390	19.4%
N	29390	19.4%
Y	591	0.4%
D	591	0.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	151340	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	45689	30.2%
A	45689	30.2%
T	29390	19.4%
N	29390	19.4%
Y	591	0.4%
D	591	0.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	151340	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	45689	30.2%
A	45689	30.2%
T	29390	19.4%
N	29390	19.4%
Y	591	0.4%
D	591	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	151340	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	45689	30.2%
A	45689	30.2%
T	29390	19.4%
N	29390	19.4%
Y	591	0.4%
D	591	0.4%

Charge Group
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.0 MiB

DSP	26206
HAUL	25416
TAX	10215
MISC	7259
FEE	6010

Length

Max length	4
Median length	3
Mean length	3.4318092
Min length	3

Characters and Unicode

Total characters	259685
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MISC
2nd row	MISC
3rd row	MISC
4th row	MISC
5th row	MISC

Common Values

Value	Count	Frequency (%)
DSP	26206	34.6%
HAUL	25416	33.6%
TAX	10215	13.5%
MISC	7259	9.6%
FEE	6010	7.9%
STD	564	0.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
dsp	26206	34.6%
haul	25416	33.6%
tax	10215	13.5%
misc	7259	9.6%
fee	6010	7.9%
std	564	0.7%

Most occurring characters

Value	Count	Frequency (%)
A	35631	13.7%
S	34029	13.1%
D	26770	10.3%
P	26206	10.1%
H	25416	9.8%
U	25416	9.8%
L	25416	9.8%
E	12020	4.6%
T	10779	4.2%
X	10215	3.9%
Other values (4)	27787	10.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	259685	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	35631	13.7%
S	34029	13.1%
D	26770	10.3%
P	26206	10.1%
H	25416	9.8%
U	25416	9.8%
L	25416	9.8%
E	12020	4.6%
T	10779	4.2%
X	10215	3.9%
Other values (4)	27787	10.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	259685	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	35631	13.7%
S	34029	13.1%
D	26770	10.3%
P	26206	10.1%
H	25416	9.8%
U	25416	9.8%
L	25416	9.8%
E	12020	4.6%
T	10779	4.2%
X	10215	3.9%
Other values (4)	27787	10.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	259685	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	35631	13.7%
S	34029	13.1%
D	26770	10.3%
P	26206	10.1%
H	25416	9.8%
U	25416	9.8%
L	25416	9.8%
E	12020	4.6%
T	10779	4.2%
X	10215	3.9%
Other values (4)	27787	10.7%

Charge Sub-Type
Categorical

HIGH CORRELATION MISSING

Distinct	19
Distinct (%)	0.1%
Missing	52372
Missing (%)	69.2%
Memory size	5.9 MiB

FRAN	4271
RENT	4228
STAT	3890
CITY	2243
TRIP	2049
Other values (14)	6617

Length

Max length	4
Median length	4
Mean length	3.9587947
Min length	3

Characters and Unicode

Total characters	92232
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	RENT
2nd row	RENT
3rd row	RENT
4th row	RENT
5th row	RENT

Common Values

Value	Count	Frequency (%)
FRAN	4271	5.6%
RENT	4228	5.6%
STAT	3890	5.1%
CITY	2243	3.0%
TRIP	2049	2.7%
CTAX	1993	2.6%
MTAX	1804	2.4%
MLFT	841	1.1%
EXSS	501	0.7%
LEGS	454	0.6%
Other values (9)	1024	1.4%
(Missing)	52372	69.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
fran	4271	18.3%
rent	4228	18.1%
stat	3890	16.7%
city	2243	9.6%
trip	2049	8.8%
ctax	1993	8.6%
mtax	1804	7.7%
mlft	841	3.6%
exss	501	2.2%
legs	454	1.9%
Other values (9)	1024	4.4%

Most occurring characters

Value	Count	Frequency (%)
T	21223	23.0%
A	12683	13.8%
R	10611	11.5%
N	8499	9.2%
E	5472	5.9%
S	5346	5.8%
F	5112	5.5%
X	4599	5.0%
I	4292	4.7%
C	4236	4.6%
Other values (11)	10159	11.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	92232	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
T	21223	23.0%
A	12683	13.8%
R	10611	11.5%
N	8499	9.2%
E	5472	5.9%
S	5346	5.8%
F	5112	5.5%
X	4599	5.0%
I	4292	4.7%
C	4236	4.6%
Other values (11)	10159	11.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	92232	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	21223	23.0%
A	12683	13.8%
R	10611	11.5%
N	8499	9.2%
E	5472	5.9%
S	5346	5.8%
F	5112	5.5%
X	4599	5.0%
I	4292	4.7%
C	4236	4.6%
Other values (11)	10159	11.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	92232	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	21223	23.0%
A	12683	13.8%
R	10611	11.5%
N	8499	9.2%
E	5472	5.9%
S	5346	5.8%
F	5112	5.5%
X	4599	5.0%
I	4292	4.7%
C	4236	4.6%
Other values (11)	10159	11.0%

Report Period
Categorical

HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	470
Missing (%)	0.6%
Memory size	7.1 MiB

Jul-22	7177
Jun-22	6809
Aug-22	6503
May-22	6500
Apr-22	6491
Other values (7)	41720

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	451200
Distinct characters	24
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Dec-22
2nd row	Nov-22
3rd row	Oct-22
4th row	Sep-22
5th row	Aug-22

Common Values

Value	Count	Frequency (%)
Jul-22	7177	9.5%
Jun-22	6809	9.0%
Aug-22	6503	8.6%
May-22	6500	8.6%
Apr-22	6491	8.6%
Sep-22	6268	8.3%
Mar-22	6247	8.3%
Feb-22	6056	8.0%
Jan-22	6038	8.0%
Oct-22	5878	7.8%
Other values (2)	11233	14.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
jul-22	7177	9.5%
jun-22	6809	9.1%
aug-22	6503	8.6%
may-22	6500	8.6%
apr-22	6491	8.6%
sep-22	6268	8.3%
mar-22	6247	8.3%
feb-22	6056	8.1%
jan-22	6038	8.0%
oct-22	5878	7.8%
Other values (2)	11233	14.9%

Most occurring characters

Value	Count	Frequency (%)
2	150400	33.3%
-	75200	16.7%
u	20489	4.5%
J	20024	4.4%
a	18785	4.2%
e	18120	4.0%
A	12994	2.9%
n	12847	2.8%
p	12759	2.8%
M	12747	2.8%
Other values (14)	96835	21.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	150400	33.3%
Lowercase Letter	150400	33.3%
Dash Punctuation	75200	16.7%
Uppercase Letter	75200	16.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
u	20489	13.6%
a	18785	12.5%
e	18120	12.0%
n	12847	8.5%
p	12759	8.5%
r	12738	8.5%
c	11674	7.8%
l	7177	4.8%
g	6503	4.3%
y	6500	4.3%
Other values (4)	22808	15.2%

Uppercase Letter

Value	Count	Frequency (%)
J	20024	26.6%
A	12994	17.3%
M	12747	17.0%
S	6268	8.3%
F	6056	8.1%
O	5878	7.8%
D	5796	7.7%
N	5437	7.2%

Decimal Number

Value	Count	Frequency (%)
2	150400	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	75200	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	225600	50.0%
Latin	225600	50.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
u	20489	9.1%
J	20024	8.9%
a	18785	8.3%
e	18120	8.0%
A	12994	5.8%
n	12847	5.7%
p	12759	5.7%
M	12747	5.7%
r	12738	5.6%
c	11674	5.2%
Other values (12)	72423	32.1%

Common

Value	Count	Frequency (%)
2	150400	66.7%
-	75200	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	451200	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	150400	33.3%
-	75200	16.7%
u	20489	4.5%
J	20024	4.4%
a	18785	4.2%
e	18120	4.0%
A	12994	2.9%
n	12847	2.8%
p	12759	2.8%
M	12747	2.8%
Other values (14)	96835	21.5%

Service Period
Categorical

HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	470
Missing (%)	0.6%
Memory size	7.1 MiB

Jul-22	7177
Jun-22	6809
Aug-22	6503
May-22	6500
Apr-22	6491
Other values (7)	41720

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	451200
Distinct characters	24
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Dec-22
2nd row	Nov-22
3rd row	Oct-22
4th row	Sep-22
5th row	Aug-22

Common Values

Value	Count	Frequency (%)
Jul-22	7177	9.5%
Jun-22	6809	9.0%
Aug-22	6503	8.6%
May-22	6500	8.6%
Apr-22	6491	8.6%
Sep-22	6268	8.3%
Mar-22	6247	8.3%
Feb-22	6056	8.0%
Jan-22	6038	8.0%
Oct-22	5878	7.8%
Other values (2)	11233	14.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
jul-22	7177	9.5%
jun-22	6809	9.1%
aug-22	6503	8.6%
may-22	6500	8.6%
apr-22	6491	8.6%
sep-22	6268	8.3%
mar-22	6247	8.3%
feb-22	6056	8.1%
jan-22	6038	8.0%
oct-22	5878	7.8%
Other values (2)	11233	14.9%

Most occurring characters

Value	Count	Frequency (%)
2	150400	33.3%
-	75200	16.7%
u	20489	4.5%
J	20024	4.4%
a	18785	4.2%
e	18120	4.0%
A	12994	2.9%
n	12847	2.8%
p	12759	2.8%
M	12747	2.8%
Other values (14)	96835	21.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	150400	33.3%
Lowercase Letter	150400	33.3%
Dash Punctuation	75200	16.7%
Uppercase Letter	75200	16.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
u	20489	13.6%
a	18785	12.5%
e	18120	12.0%
n	12847	8.5%
p	12759	8.5%
r	12738	8.5%
c	11674	7.8%
l	7177	4.8%
g	6503	4.3%
y	6500	4.3%
Other values (4)	22808	15.2%

Uppercase Letter

Value	Count	Frequency (%)
J	20024	26.6%
A	12994	17.3%
M	12747	17.0%
S	6268	8.3%
F	6056	8.1%
O	5878	7.8%
D	5796	7.7%
N	5437	7.2%

Decimal Number

Value	Count	Frequency (%)
2	150400	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	75200	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	225600	50.0%
Latin	225600	50.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
u	20489	9.1%
J	20024	8.9%
a	18785	8.3%
e	18120	8.0%
A	12994	5.8%
n	12847	5.7%
p	12759	5.7%
M	12747	5.7%
r	12738	5.6%
c	11674	5.2%
Other values (12)	72423	32.1%

Common

Value	Count	Frequency (%)
2	150400	66.7%
-	75200	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	451200	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	150400	33.3%
-	75200	16.7%
u	20489	4.5%
J	20024	4.4%
a	18785	4.2%
e	18120	4.0%
A	12994	2.9%
n	12847	2.8%
p	12759	2.8%
M	12747	2.8%
Other values (14)	96835	21.5%

Original Volume
Real number (ℝ)

HIGH CORRELATION

Distinct	570
Distinct (%)	0.8%
Missing	470
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%
Mean	33.99846

Minimum	0
Maximum	270
Zeros	320
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	4.21
Q1	16.46
median	24.57
Q3	36.56
95-th percentile	97.33
Maximum	270
Range	270
Interquartile range (IQR)	20.1

Descriptive statistics

Standard deviation	31.150554
Coefficient of variation (CV)	0.91623426
Kurtosis	9.6204505
Mean	33.99846
Median Absolute Deviation (MAD)	9.32
Skewness	2.5208257
Sum	2556684.2
Variance	970.35701
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
34.64	756	1.0%
29.73	512	0.7%
3.81	466	0.6%
14	466	0.6%
105.32	466	0.6%
118.73	466	0.6%
92.56	466	0.6%
112.69	466	0.6%
89.82	466	0.6%
110.76	466	0.6%
Other values (560)	70204	92.8%
(Missing)	470	0.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	320	0.4%
0.31	83	0.1%
0.33	5	< 0.1%
0.41	9	< 0.1%
0.47	7	< 0.1%
0.57	8	< 0.1%
0.58	11	< 0.1%
0.63	5	< 0.1%
0.64	67	0.1%
0.86	16	< 0.1%

Value	Count	Frequency (%)
270	115	0.2%
220	115	0.2%
200	115	0.2%
190	92	0.1%
180	115	0.2%
140	115	0.2%
136	330	0.4%
120	115	0.2%
119.65	466	0.6%
118.73	466	0.6%

UOM for Volume
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	< 0.1%
Missing	470
Missing (%)	0.6%
Memory size	6.8 MiB

TN	71412
YD	3198
Other Quantity	590

Length

Max length	14
Median length	2
Mean length	2.0941489
Min length	2

Characters and Unicode

Total characters	157480
Distinct characters	16
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	TN
2nd row	TN
3rd row	TN
4th row	TN
5th row	TN

Common Values

Value	Count	Frequency (%)
TN	71412	94.4%
YD	3198	4.2%
Other Quantity	590	0.8%
(Missing)	470	0.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
tn	71412	94.2%
yd	3198	4.2%
other	590	0.8%
quantity	590	0.8%

Most occurring characters

Value	Count	Frequency (%)
T	71412	45.3%
N	71412	45.3%
Y	3198	2.0%
D	3198	2.0%
t	1770	1.1%
O	590	0.4%
h	590	0.4%
e	590	0.4%
r	590	0.4%
	590	0.4%
Other values (6)	3540	2.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	150400	95.5%
Lowercase Letter	6490	4.1%
Space Separator	590	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	1770	27.3%
h	590	9.1%
e	590	9.1%
r	590	9.1%
u	590	9.1%
a	590	9.1%
n	590	9.1%
i	590	9.1%
y	590	9.1%

Uppercase Letter

Value	Count	Frequency (%)
T	71412	47.5%
N	71412	47.5%
Y	3198	2.1%
D	3198	2.1%
O	590	0.4%
Q	590	0.4%

Space Separator

Value	Count	Frequency (%)
	590	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	156890	99.6%
Common	590	0.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	71412	45.5%
N	71412	45.5%
Y	3198	2.0%
D	3198	2.0%
t	1770	1.1%
O	590	0.4%
h	590	0.4%
e	590	0.4%
r	590	0.4%
Q	590	0.4%
Other values (5)	2950	1.9%

Common

Value	Count	Frequency (%)
	590	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	157480	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	71412	45.3%
N	71412	45.3%
Y	3198	2.0%
D	3198	2.0%
t	1770	1.1%
O	590	0.4%
h	590	0.4%
e	590	0.4%
r	590	0.4%
	590	0.4%
Other values (6)	3540	2.2%

Pounds per Yard
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	470
Missing (%)	0.6%
Memory size	7.1 MiB

300.0	46399
100.0	27830
50.0	971

Length

Max length	5
Median length	5
Mean length	4.9870878
Min length	4

Characters and Unicode

Total characters	375029
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	100.0
2nd row	100.0
3rd row	100.0
4th row	100.0
5th row	100.0

Common Values

Value	Count	Frequency (%)
300.0	46399	61.3%
100.0	27830	36.8%
50.0	971	1.3%
(Missing)	470	0.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
300.0	46399	61.7%
100.0	27830	37.0%
50.0	971	1.3%

Most occurring characters

Value	Count	Frequency (%)
0	224629	59.9%
.	75200	20.1%
3	46399	12.4%
1	27830	7.4%
5	971	0.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	299829	79.9%
Other Punctuation	75200	20.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	224629	74.9%
3	46399	15.5%
1	27830	9.3%
5	971	0.3%

Other Punctuation

Value	Count	Frequency (%)
.	75200	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	375029	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	224629	59.9%
.	75200	20.1%
3	46399	12.4%
1	27830	7.4%
5	971	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	375029	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	224629	59.9%
.	75200	20.1%
3	46399	12.4%
1	27830	7.4%
5	971	0.3%

Trash Tons
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	562
Distinct (%)	0.7%
Missing	470
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%
Mean	30.944807

Minimum	0
Maximum	136
Zeros	1772
Zeros (%)	2.3%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	2.66
Q1	15.14
median	23.83
Q3	34.07
95-th percentile	92.56
Maximum	136
Range	136
Interquartile range (IQR)	18.93

Descriptive statistics

Standard deviation	26.662949
Coefficient of variation (CV)	0.86162919
Kurtosis	2.5196267
Mean	30.944807
Median Absolute Deviation (MAD)	9.37
Skewness	1.6611463
Sum	2327049.5
Variance	710.91283
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1772	2.3%
29.73	512	0.7%
73.44	466	0.6%
3.81	466	0.6%
94.83	466	0.6%
105.32	466	0.6%
118.73	466	0.6%
92.56	466	0.6%
112.69	466	0.6%
89.82	466	0.6%
Other values (552)	69188	91.4%
(Missing)	470	0.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1772	2.3%
0.31	83	0.1%
0.33	5	< 0.1%
0.41	9	< 0.1%
0.47	7	< 0.1%
0.57	8	< 0.1%
0.58	11	< 0.1%
0.63	5	< 0.1%
0.64	67	0.1%
0.8	235	0.3%

Value	Count	Frequency (%)
136	330	0.4%
119.65	466	0.6%
118.73	466	0.6%
112.69	466	0.6%
110.76	466	0.6%
105.32	466	0.6%
97.33	456	0.6%
94.83	466	0.6%
92.56	466	0.6%
89.82	466	0.6%

Recycle Tons
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	6
Distinct (%)	< 0.1%
Missing	470
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%
Mean	0.011180984

Minimum	0
Maximum	5.4
Zeros	74338
Zeros (%)	98.2%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	5.4
Range	5.4
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.1346087
Coefficient of variation (CV)	12.039074
Kurtosis	697.17798
Mean	0.011180984
Median Absolute Deviation (MAD)	0
Skewness	22.471008
Sum	840.81
Variance	0.018119502
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	74338	98.2%
0.87	756	1.0%
0.11	67	0.1%
4.2	16	< 0.1%
4.42	16	< 0.1%
5.4	7	< 0.1%
(Missing)	470	0.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	74338	98.2%
0.11	67	0.1%
0.87	756	1.0%
4.2	16	< 0.1%
4.42	16	< 0.1%
5.4	7	< 0.1%

Value	Count	Frequency (%)
5.4	7	< 0.1%
4.42	16	< 0.1%
4.2	16	< 0.1%
0.87	756	1.0%
0.11	67	0.1%
0	74338	98.2%

Tons Derived
Boolean

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	470
Missing (%)	0.6%
Memory size	2.7 MiB

False	72002
True	3198
(Missing)	470

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	72002	95.2%
True	3198	4.2%
(Missing)	470	0.6%

Auto

Heatmap
Table

	Address	Asset Category	Asset Type	Charge Code Desc.	Charge Group	Charge Sub-Type	City	Container Size	Container Type	Invoice Number	Location ID	Original Volume	Pounds per Yard	Quantity	Recycle Tons	Report Period	Service Period	State	Tons Derived	Trash Tons	UOM for Volume	Unit of Measure	Waste Stream	Waste Type	Zip Code
Address	1.000	0.404	0.624	0.363	0.302	0.517	0.966	0.080	0.464	0.001	0.985	0.131	0.584	-0.043	0.084	0.076	0.076	1.000	0.421	0.099	0.354	0.283	0.434	0.443	-0.025
Asset Category	0.404	1.000	0.086	0.565	0.475	0.362	0.404	0.485	1.000	-0.019	0.403	0.016	0.684	0.114	-0.631	0.000	0.000	0.155	0.771	0.268	0.771	0.131	0.706	0.722	-0.054
Asset Type	0.624	0.086	1.000	0.200	0.142	0.291	0.596	-0.170	0.127	0.011	0.619	-0.144	0.748	-0.001	-0.051	0.065	0.065	0.325	0.060	-0.194	0.078	0.150	0.057	0.394	-0.141
Charge Code Desc.	0.363	0.565	0.200	1.000	1.000	1.000	0.360	-0.012	0.392	-0.025	0.323	0.003	0.386	-0.416	0.058	0.009	0.009	0.306	0.433	-0.028	0.313	0.667	0.468	0.293	-0.001
Charge Group	0.302	0.475	0.142	1.000	1.000	1.000	0.299	-0.077	0.257	0.013	0.301	-0.155	0.204	-0.575	0.105	0.011	0.011	0.181	0.358	-0.194	0.256	0.653	0.216	0.149	0.127
Charge Sub-Type	0.517	0.362	0.291	1.000	1.000	1.000	0.514	0.047	0.261	-0.026	0.458	-0.111	0.349	-0.038	-0.026	0.000	0.000	0.345	0.320	-0.107	0.264	0.415	0.360	0.265	-0.042
City	0.966	0.404	0.596	0.360	0.299	0.514	1.000	0.066	0.464	0.013	0.949	-0.030	0.571	0.043	-0.120	0.071	0.071	1.000	0.417	-0.005	0.352	0.277	0.434	0.440	-0.285
Container Size	0.080	0.485	-0.170	-0.012	-0.077	0.047	0.066	1.000	0.577	-0.063	0.467	0.242	0.613	0.106	-0.308	0.051	0.051	0.380	0.771	0.355	0.546	0.099	0.781	0.522	-0.117
Container Type	0.464	1.000	0.127	0.392	0.257	0.261	0.464	0.577	1.000	-0.013	0.474	0.001	0.668	0.098	-0.461	0.018	0.018	0.135	0.771	0.193	0.545	0.096	0.940	0.716	-0.059
Invoice Number	0.001	-0.019	0.011	-0.025	0.013	-0.026	0.013	-0.063	-0.013	1.000	0.149	-0.025	0.073	0.016	0.009	0.035	0.035	0.074	0.016	-0.015	0.066	0.069	0.041	0.066	0.001
Location ID	0.985	0.403	0.619	0.323	0.301	0.458	0.949	0.467	0.474	0.149	1.000	-0.011	0.581	0.014	0.087	0.062	0.062	1.000	0.420	-0.091	0.354	0.280	0.434	0.438	0.479
Original Volume	0.131	0.016	-0.144	0.003	-0.155	-0.111	-0.030	0.242	0.001	-0.025	-0.011	1.000	0.257	0.068	0.054	0.163	0.163	0.240	0.423	0.880	0.304	0.205	0.135	0.223	-0.300
Pounds per Yard	0.584	0.684	0.748	0.386	0.204	0.349	0.571	0.613	0.668	0.073	0.581	0.257	1.000	0.065	-0.211	0.035	0.035	0.238	0.550	0.258	0.391	0.102	0.956	0.703	-0.087
Quantity	-0.043	0.114	-0.001	-0.416	-0.575	-0.038	0.043	0.106	0.098	0.016	0.014	0.068	0.065	1.000	-0.074	0.021	0.021	0.152	0.213	0.083	0.152	0.840	0.063	0.190	-0.010
Recycle Tons	0.084	-0.631	-0.051	0.058	0.105	-0.026	-0.120	-0.308	-0.461	0.009	0.087	0.054	-0.211	-0.074	1.000	0.036	0.036	0.082	0.478	-0.182	0.338	0.058	0.864	0.707	0.071
Report Period	0.076	0.000	0.065	0.009	0.011	0.000	0.071	0.051	0.018	0.035	0.062	0.163	0.035	0.021	0.036	1.000	1.000	0.040	0.059	0.047	0.161	0.042	0.000	0.053	0.012
Service Period	0.076	0.000	0.065	0.009	0.011	0.000	0.071	0.051	0.018	0.035	0.062	0.163	0.035	0.021	0.036	1.000	1.000	0.040	0.059	0.047	0.161	0.042	0.000	0.053	0.012
State	1.000	0.155	0.325	0.306	0.181	0.345	1.000	0.380	0.135	0.074	1.000	0.240	0.238	0.152	0.082	0.040	0.040	1.000	0.303	-0.109	0.238	0.256	0.121	0.351	-0.080
Tons Derived	0.421	0.771	0.060	0.433	0.358	0.320	0.417	0.771	0.771	0.016	0.420	0.423	0.550	0.213	0.478	0.059	0.059	0.303	1.000	-0.317	1.000	0.230	0.546	0.641	0.030
Trash Tons	0.099	0.268	-0.194	-0.028	-0.194	-0.107	-0.005	0.355	0.193	-0.015	-0.091	0.880	0.258	0.083	-0.182	0.047	0.047	-0.109	-0.317	1.000	0.300	0.142	0.220	0.213	-0.297
UOM for Volume	0.354	0.771	0.078	0.313	0.256	0.264	0.352	0.546	0.545	0.066	0.354	0.304	0.391	0.152	0.338	0.161	0.161	0.238	1.000	0.300	1.000	0.163	0.546	0.453	0.041
Unit of Measure	0.283	0.131	0.150	0.667	0.653	0.415	0.277	0.099	0.096	0.069	0.280	0.205	0.102	0.840	0.058	0.042	0.042	0.256	0.230	0.142	0.163	1.000	0.094	0.273	-0.000
Waste Stream	0.434	0.706	0.057	0.468	0.216	0.360	0.434	0.781	0.940	0.041	0.434	0.135	0.956	0.063	0.864	0.000	0.000	0.121	0.546	0.220	0.546	0.094	1.000	0.985	-0.044
Waste Type	0.443	0.722	0.394	0.293	0.149	0.265	0.440	0.522	0.716	0.066	0.438	0.223	0.703	0.190	0.707	0.053	0.053	0.351	0.641	0.213	0.453	0.273	0.985	1.000	0.054
Zip Code	-0.025	-0.054	-0.141	-0.001	0.127	-0.042	-0.285	-0.117	-0.059	0.001	0.479	-0.300	-0.087	-0.010	0.071	0.012	0.012	-0.080	0.030	-0.297	0.041	-0.000	-0.044	0.054	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	Location ID	Invoice Number	Account	Asset ID	Location	Address	City	State	Zip Code	Container Type	Container Size	Compactor	Asset Type	Asset Category	Waste Stream	Waste Type	Report Date	Charge Date	Charge Amount	Charge Code Desc.	From Date	To Date	Quantity	Unit of Measure	Charge Group	Charge Sub-Type	Report Period	Service Period	Original Volume	UOM for Volume	Pounds per Yard	Trash Tons	Tons Derived
0	101	20221200	800-0303937	800-0303937-00001-01	FLOOR & DECOR 101 30YD CLEANUP	1690 NORTHEAST EXPY NE	BROOKHAVEN	GA	30329	RO	30	NaN	TEMPORARY	Industrial	Trash	NONE	12/1/2022	12/31/2022	$77.25	CONTAINER/COMPACTOR RENTAL	1/1/2023	1/31/2023	1.00	EA	MISC	RENT	Dec-22	Dec-22	17.16	TN	100.0	17.16	N
1	101	20221200	800-0303937	800-0303937-00001-01	FLOOR & DECOR 101 30YD CLEANUP	1690 NORTHEAST EXPY NE	BROOKHAVEN	GA	30329	RO	30	NaN	TEMPORARY	Industrial	Trash	NONE	12/1/2022	12/31/2022	$77.25	CONTAINER/COMPACTOR RENTAL	1/1/2023	1/31/2023	1.00	EA	MISC	RENT	Nov-22	Nov-22	15.67	TN	100.0	15.67	N
2	101	20221200	800-0303937	800-0303937-00001-01	FLOOR & DECOR 101 30YD CLEANUP	1690 NORTHEAST EXPY NE	BROOKHAVEN	GA	30329	RO	30	NaN	TEMPORARY	Industrial	Trash	NONE	12/1/2022	12/31/2022	$77.25	CONTAINER/COMPACTOR RENTAL	1/1/2023	1/31/2023	1.00	EA	MISC	RENT	Oct-22	Oct-22	20.21	TN	100.0	20.21	N
3	101	20221200	800-0303937	800-0303937-00001-01	FLOOR & DECOR 101 30YD CLEANUP	1690 NORTHEAST EXPY NE	BROOKHAVEN	GA	30329	RO	30	NaN	TEMPORARY	Industrial	Trash	NONE	12/1/2022	12/31/2022	$77.25	CONTAINER/COMPACTOR RENTAL	1/1/2023	1/31/2023	1.00	EA	MISC	RENT	Sep-22	Sep-22	14.61	TN	100.0	14.61	N
4	101	20221200	800-0303937	800-0303937-00001-01	FLOOR & DECOR 101 30YD CLEANUP	1690 NORTHEAST EXPY NE	BROOKHAVEN	GA	30329	RO	30	NaN	TEMPORARY	Industrial	Trash	NONE	12/1/2022	12/31/2022	$77.25	CONTAINER/COMPACTOR RENTAL	1/1/2023	1/31/2023	1.00	EA	MISC	RENT	Aug-22	Aug-22	13.16	TN	100.0	13.16	N
5	101	20221200	800-0303937	800-0303937-00001-01	FLOOR & DECOR 101 30YD CLEANUP	1690 NORTHEAST EXPY NE	BROOKHAVEN	GA	30329	RO	30	NaN	TEMPORARY	Industrial	Trash	NONE	12/1/2022	12/1/2022	$95.86	DISPOSAL CHARGE	12/1/2022	12/1/2022	1.77	TN	DSP	NaN	Dec-22	Dec-22	17.16	TN	100.0	17.16	N
6	101	20221200	800-0303937	800-0303937-00001-01	FLOOR & DECOR 101 30YD CLEANUP	1690 NORTHEAST EXPY NE	BROOKHAVEN	GA	30329	RO	30	NaN	TEMPORARY	Industrial	Trash	NONE	12/1/2022	12/1/2022	$95.86	DISPOSAL CHARGE	12/1/2022	12/1/2022	1.77	TN	DSP	NaN	Nov-22	Nov-22	15.67	TN	100.0	15.67	N
7	101	20221200	800-0303937	800-0303937-00001-01	FLOOR & DECOR 101 30YD CLEANUP	1690 NORTHEAST EXPY NE	BROOKHAVEN	GA	30329	RO	30	NaN	TEMPORARY	Industrial	Trash	NONE	12/1/2022	12/1/2022	$95.86	DISPOSAL CHARGE	12/1/2022	12/1/2022	1.77	TN	DSP	NaN	Oct-22	Oct-22	20.21	TN	100.0	20.21	N
8	101	20221200	800-0303937	800-0303937-00001-01	FLOOR & DECOR 101 30YD CLEANUP	1690 NORTHEAST EXPY NE	BROOKHAVEN	GA	30329	RO	30	NaN	TEMPORARY	Industrial	Trash	NONE	12/1/2022	12/1/2022	$95.86	DISPOSAL CHARGE	12/1/2022	12/1/2022	1.77	TN	DSP	NaN	Sep-22	Sep-22	14.61	TN	100.0	14.61	N
9	101	20221200	800-0303937	800-0303937-00001-01	FLOOR & DECOR 101 30YD CLEANUP	1690 NORTHEAST EXPY NE	BROOKHAVEN	GA	30329	RO	30	NaN	TEMPORARY	Industrial	Trash	NONE	12/1/2022	12/1/2022	$95.86	DISPOSAL CHARGE	12/1/2022	12/1/2022	1.77	TN	DSP	NaN	Aug-22	Aug-22	13.16	TN	100.0	13.16	N

	Location ID	Invoice Number	Account	Asset ID	Location	Address	City	State	Zip Code	Container Type	Container Size	Compactor	Asset Type	Asset Category	Waste Stream	Waste Type	Report Date	Charge Date	Charge Amount	Charge Code Desc.	From Date	To Date	Quantity	Unit of Measure	Charge Group	Charge Sub-Type	Report Period	Service Period	Original Volume	UOM for Volume	Pounds per Yard	Trash Tons	Recycle Tons	Tons Derived
75660	DC 991	20220100	853-0136012	853-0136012-00001-01	FLOOR AND DECOR DC 991 40YD	5120 CEDAR PORT PKWY	BAYTOWN	TX	77523	RO	40	NaN	PERMANENT	Industrial	Trash	NONE	1/1/2022	1/4/2022	$435.72	STATE TAX	1/4/2022	1/4/2022	2.81	TN	TAX	STAT	Sep-22	Sep-22	28.84	TN	100.0	28.84	0.0	N
75661	DC 991	20220100	853-0136012	853-0136012-00001-01	FLOOR AND DECOR DC 991 40YD	5120 CEDAR PORT PKWY	BAYTOWN	TX	77523	RO	40	NaN	PERMANENT	Industrial	Trash	NONE	1/1/2022	1/4/2022	$435.72	STATE TAX	1/4/2022	1/4/2022	2.81	TN	TAX	STAT	Aug-22	Aug-22	52.83	TN	100.0	52.83	0.0	N
75662	DC 991	20220100	853-0136012	853-0136012-00001-01	FLOOR AND DECOR DC 991 40YD	5120 CEDAR PORT PKWY	BAYTOWN	TX	77523	RO	40	NaN	PERMANENT	Industrial	Trash	NONE	1/1/2022	1/4/2022	$435.72	STATE TAX	1/4/2022	1/4/2022	2.81	TN	TAX	STAT	Jul-22	Jul-22	58.58	TN	100.0	58.58	0.0	N
75663	DC 991	20220100	853-0136012	853-0136012-00001-01	FLOOR AND DECOR DC 991 40YD	5120 CEDAR PORT PKWY	BAYTOWN	TX	77523	RO	40	NaN	PERMANENT	Industrial	Trash	NONE	1/1/2022	1/4/2022	$435.72	STATE TAX	1/4/2022	1/4/2022	2.81	TN	TAX	STAT	Jun-22	Jun-22	56.12	TN	100.0	56.12	0.0	N
75664	DC 991	20220100	853-0136012	853-0136012-00001-01	FLOOR AND DECOR DC 991 40YD	5120 CEDAR PORT PKWY	BAYTOWN	TX	77523	RO	40	NaN	PERMANENT	Industrial	Trash	NONE	1/1/2022	1/4/2022	$435.72	STATE TAX	1/4/2022	1/4/2022	2.81	TN	TAX	STAT	May-22	May-22	70.07	TN	100.0	70.07	0.0	N
75665	DC 991	20220100	853-0136012	853-0136012-00001-01	FLOOR AND DECOR DC 991 40YD	5120 CEDAR PORT PKWY	BAYTOWN	TX	77523	RO	40	NaN	PERMANENT	Industrial	Trash	NONE	1/1/2022	1/4/2022	$435.72	STATE TAX	1/4/2022	1/4/2022	2.81	TN	TAX	STAT	Apr-22	Apr-22	60.74	TN	100.0	60.74	0.0	N
75666	DC 991	20220100	853-0136012	853-0136012-00001-01	FLOOR AND DECOR DC 991 40YD	5120 CEDAR PORT PKWY	BAYTOWN	TX	77523	RO	40	NaN	PERMANENT	Industrial	Trash	NONE	1/1/2022	1/4/2022	$435.72	STATE TAX	1/4/2022	1/4/2022	2.81	TN	TAX	STAT	Mar-22	Mar-22	48.04	TN	100.0	48.04	0.0	N
75667	DC 991	20220100	853-0136012	853-0136012-00001-01	FLOOR AND DECOR DC 991 40YD	5120 CEDAR PORT PKWY	BAYTOWN	TX	77523	RO	40	NaN	PERMANENT	Industrial	Trash	NONE	1/1/2022	1/4/2022	$435.72	STATE TAX	1/4/2022	1/4/2022	2.81	TN	TAX	STAT	Feb-22	Feb-22	52.36	TN	100.0	52.36	0.0	N
75668	DC 991	20220100	853-0136012	853-0136012-00001-01	FLOOR AND DECOR DC 991 40YD	5120 CEDAR PORT PKWY	BAYTOWN	TX	77523	RO	40	NaN	PERMANENT	Industrial	Trash	NONE	1/1/2022	1/4/2022	$435.72	STATE TAX	1/4/2022	1/4/2022	2.81	TN	TAX	STAT	Jan-22	Jan-22	29.55	TN	100.0	29.55	0.0	N
75669	GJTEMP12	20220700	625-8126942	625-8126942-00001-01	FLOOR & DECOR 188 GJ TEMP	16300 W BLUEMOUND RD	BROOKFIELD	WI	53005	HP	0	NaN	TEMPORARY	Commercial	Trash	NONE	7/1/2022	6/11/2022	$1,673.41	GOT JUNK	6/11/2022	6/11/2022	1.00	EA	MISC	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Most frequently occurring

	Location ID	Invoice Number	Account	Asset ID	Location	Address	City	State	Zip Code	Container Type	Container Size	Compactor	Asset Type	Asset Category	Waste Stream	Waste Type	Report Date	Charge Date	Charge Amount	Charge Code Desc.	From Date	To Date	Quantity	Unit of Measure	Charge Group	Charge Sub-Type	Report Period	Service Period	Original Volume	UOM for Volume	Pounds per Yard	Trash Tons	Tons Derived	# duplicates
0	102	20220900	800-0304124	800-0304124-00001-01	FLOOR & DECOR 102 30YD CLOSING	1056 PERSONAL PL	MORROW	GA	30260	RO	30	NaN	TEMPORARY	Industrial	Trash	NONE	9/1/2022	9/9/2022	$175.00	SERVICE ATTEMPT	9/9/2022	9/9/2022	1.0	EA	MISC	TRIP	Jul-22	Jul-22	3.93	TN	100.0	3.93	N	3
1	102	20221000	800-0303428	800-0303428-00001-01	FLOOR & DECOR 102 C&D TEMP	1056 PERSONAL PL	MORROW	GA	30260	RO	30	NaN	TEMPORARY	Industrial	Trash	CONSTRUCTION/DEMOLITION DEBRIS	10/1/2022	10/13/2022	$160.44	HAUL	10/13/2022	10/13/2022	1.0	EA	HAUL	NaN	Jul-22	Jul-22	27.29	TN	100.0	27.29	N	3
2	102	20221000	800-0303428	800-0303428-00001-01	FLOOR & DECOR 102 C&D TEMP	1056 PERSONAL PL	MORROW	GA	30260	RO	30	NaN	TEMPORARY	Industrial	Trash	CONSTRUCTION/DEMOLITION DEBRIS	10/1/2022	10/13/2022	$160.44	HAUL	10/13/2022	10/13/2022	1.0	EA	HAUL	NaN	Oct-22	Oct-22	17.80	TN	100.0	17.80	N	3
3	105	20220600	853-0124694	853-0124694-00001-01	FLOOR & DECOR TEMP	17211 NORTH FWY	HOUSTON	TX	77090	RO	40	NaN	TEMPORARY	Industrial	Trash	NONE	6/1/2022	6/29/2022	$335.98	HAUL	6/29/2022	6/29/2022	1.0	EA	HAUL	NaN	Apr-22	Apr-22	19.76	TN	100.0	19.76	N	2
4	105	20220600	853-0124694	853-0124694-00001-01	FLOOR & DECOR TEMP	17211 NORTH FWY	HOUSTON	TX	77090	RO	40	NaN	TEMPORARY	Industrial	Trash	NONE	6/1/2022	6/29/2022	$335.98	HAUL	6/29/2022	6/29/2022	1.0	EA	HAUL	NaN	Aug-22	Aug-22	22.67	TN	100.0	22.67	N	2
5	105	20220600	853-0124694	853-0124694-00001-01	FLOOR & DECOR TEMP	17211 NORTH FWY	HOUSTON	TX	77090	RO	40	NaN	TEMPORARY	Industrial	Trash	NONE	6/1/2022	6/29/2022	$335.98	HAUL	6/29/2022	6/29/2022	1.0	EA	HAUL	NaN	Feb-22	Feb-22	7.40	TN	100.0	7.40	N	2
6	105	20220600	853-0124694	853-0124694-00001-01	FLOOR & DECOR TEMP	17211 NORTH FWY	HOUSTON	TX	77090	RO	40	NaN	TEMPORARY	Industrial	Trash	NONE	6/1/2022	6/29/2022	$335.98	HAUL	6/29/2022	6/29/2022	1.0	EA	HAUL	NaN	Jan-22	Jan-22	25.95	TN	100.0	25.95	N	2
7	105	20220600	853-0124694	853-0124694-00001-01	FLOOR & DECOR TEMP	17211 NORTH FWY	HOUSTON	TX	77090	RO	40	NaN	TEMPORARY	Industrial	Trash	NONE	6/1/2022	6/29/2022	$335.98	HAUL	6/29/2022	6/29/2022	1.0	EA	HAUL	NaN	Jul-22	Jul-22	13.88	TN	100.0	13.88	N	2
8	105	20220600	853-0124694	853-0124694-00001-01	FLOOR & DECOR TEMP	17211 NORTH FWY	HOUSTON	TX	77090	RO	40	NaN	TEMPORARY	Industrial	Trash	NONE	6/1/2022	6/29/2022	$335.98	HAUL	6/29/2022	6/29/2022	1.0	EA	HAUL	NaN	Jun-22	Jun-22	12.07	TN	100.0	12.07	N	2
9	105	20220600	853-0124694	853-0124694-00001-01	FLOOR & DECOR TEMP	17211 NORTH FWY	HOUSTON	TX	77090	RO	40	NaN	TEMPORARY	Industrial	Trash	NONE	6/1/2022	6/29/2022	$335.98	HAUL	6/29/2022	6/29/2022	1.0	EA	HAUL	NaN	Mar-22	Mar-22	13.59	TN	100.0	13.59	N	2

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Space Separator

Other Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script